Loan Approval Dataset

Dataset statistics

Number of variables	13
Number of observations	4269
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.1 MiB
Average record size in memory	274.5 B

Variable types

Numeric	10
Categorical	3

Alerts

`income_annum` is highly overall correlated with `loan_amount` and 4 other fields	High correlation
`loan_amount` is highly overall correlated with `income_annum` and 4 other fields	High correlation
`cibil_score` is highly overall correlated with `loan_status`	High correlation
`residential_assets_value` is highly overall correlated with `income_annum` and 3 other fields	High correlation
`commercial_assets_value` is highly overall correlated with `income_annum` and 3 other fields	High correlation
`luxury_assets_value` is highly overall correlated with `income_annum` and 4 other fields	High correlation
`bank_asset_value` is highly overall correlated with `income_annum` and 4 other fields	High correlation
`loan_status` is highly overall correlated with `cibil_score`	High correlation
`loan_id` is uniformly distributed	Uniform
`loan_id` has unique values	Unique
`no_of_dependents` has 712 (16.7%) zeros	Zeros
`residential_assets_value` has 45 (1.1%) zeros	Zeros
`commercial_assets_value` has 107 (2.5%) zeros	Zeros

Reproduction

Analysis started	2023-09-05 13:43:52.553887
Analysis finished	2023-09-05 13:44:19.954320
Duration	27.4 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

loan_id
Real number (ℝ)

UNIFORM UNIQUE

Distinct	4269
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2135

Minimum	1
Maximum	4269
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.5 KiB

Quantile statistics

Minimum	1
5-th percentile	214.4
Q1	1068
median	2135
Q3	3202
95-th percentile	4055.6
Maximum	4269
Range	4268
Interquartile range (IQR)	2134

Descriptive statistics

Standard deviation	1232.4985
Coefficient of variation (CV)	0.57728266
Kurtosis	-1.2
Mean	2135
Median Absolute Deviation (MAD)	1067
Skewness	0
Sum	9114315
Variance	1519052.5
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
2852	1	< 0.1%
2838	1	< 0.1%
2839	1	< 0.1%
2840	1	< 0.1%
2841	1	< 0.1%
2842	1	< 0.1%
2843	1	< 0.1%
2844	1	< 0.1%
2845	1	< 0.1%
Other values (4259)	4259	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
4269	1	< 0.1%
4268	1	< 0.1%
4267	1	< 0.1%
4266	1	< 0.1%
4265	1	< 0.1%
4264	1	< 0.1%
4263	1	< 0.1%
4262	1	< 0.1%
4261	1	< 0.1%
4260	1	< 0.1%

no_of_dependents
Real number (ℝ)

ZEROS

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.4987116

Minimum	0
Maximum	5
Zeros	712
Zeros (%)	16.7%
Negative	0
Negative (%)	0.0%
Memory size	33.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	4
95-th percentile	5
Maximum	5
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.6959102
Coefficient of variation (CV)	0.67871383
Kurtosis	-1.2569922
Mean	2.4987116
Median Absolute Deviation (MAD)	1
Skewness	-0.017970543
Sum	10667
Variance	2.8761113
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
4	752	17.6%
3	727	17.0%
0	712	16.7%
2	708	16.6%
1	697	16.3%
5	673	15.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	712	16.7%
1	697	16.3%
2	708	16.6%
3	727	17.0%
4	752	17.6%
5	673	15.8%

Value	Count	Frequency (%)
5	673	15.8%
4	752	17.6%
3	727	17.0%
2	708	16.6%
1	697	16.3%
0	712	16.7%

education
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	283.6 KiB

Graduate	2144
Not Graduate	2125

Length

Max length	13
Median length	9
Mean length	10.991099
Min length	9

Characters and Unicode

Total characters	46921
Distinct characters	10
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Graduate
2nd row	Not Graduate
3rd row	Graduate
4th row	Graduate
5th row	Not Graduate

Common Values

Value	Count	Frequency (%)
Graduate	2144	50.2%
Not Graduate	2125	49.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
graduate	4269	66.8%
not	2125	33.2%

Most occurring characters

Value	Count	Frequency (%)
a	8538	18.2%
	6394	13.6%
t	6394	13.6%
G	4269	9.1%
r	4269	9.1%
d	4269	9.1%
u	4269	9.1%
e	4269	9.1%
N	2125	4.5%
o	2125	4.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	34133	72.7%
Space Separator	6394	13.6%
Uppercase Letter	6394	13.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	8538	25.0%
t	6394	18.7%
r	4269	12.5%
d	4269	12.5%
u	4269	12.5%
e	4269	12.5%
o	2125	6.2%

Uppercase Letter

Value	Count	Frequency (%)
G	4269	66.8%
N	2125	33.2%

Space Separator

Value	Count	Frequency (%)
	6394	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	40527	86.4%
Common	6394	13.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	8538	21.1%
t	6394	15.8%
G	4269	10.5%
r	4269	10.5%
d	4269	10.5%
u	4269	10.5%
e	4269	10.5%
N	2125	5.2%
o	2125	5.2%

Common

Value	Count	Frequency (%)
	6394	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46921	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	8538	18.2%
	6394	13.6%
t	6394	13.6%
G	4269	9.1%
r	4269	9.1%
d	4269	9.1%
u	4269	9.1%
e	4269	9.1%
N	2125	4.5%
o	2125	4.5%

self_employed
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	252.4 KiB

Yes	2150
No	2119

Length

Max length	4
Median length	4
Mean length	3.5036308
Min length	3

Characters and Unicode

Total characters	14957
Distinct characters	6
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	Yes
3rd row	No
4th row	No
5th row	Yes

Common Values

Value	Count	Frequency (%)
Yes	2150	50.4%
No	2119	49.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
yes	2150	50.4%
no	2119	49.6%

Most occurring characters

Value	Count	Frequency (%)
	4269	28.5%
Y	2150	14.4%
e	2150	14.4%
s	2150	14.4%
N	2119	14.2%
o	2119	14.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6419	42.9%
Space Separator	4269	28.5%
Uppercase Letter	4269	28.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2150	33.5%
s	2150	33.5%
o	2119	33.0%

Uppercase Letter

Value	Count	Frequency (%)
Y	2150	50.4%
N	2119	49.6%

Space Separator

Value	Count	Frequency (%)
	4269	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10688	71.5%
Common	4269	28.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
Y	2150	20.1%
e	2150	20.1%
s	2150	20.1%
N	2119	19.8%
o	2119	19.8%

Common

Value	Count	Frequency (%)
	4269	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14957	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	4269	28.5%
Y	2150	14.4%
e	2150	14.4%
s	2150	14.4%
N	2119	14.2%
o	2119	14.2%

income_annum
Real number (ℝ)

HIGH CORRELATION

Distinct	98
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5059123.9

Minimum	200000
Maximum	9900000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.5 KiB

Quantile statistics

Minimum	200000
5-th percentile	600000
Q1	2700000
median	5100000
Q3	7500000
95-th percentile	9400000
Maximum	9900000
Range	9700000
Interquartile range (IQR)	4800000

Descriptive statistics

Standard deviation	2806839.8
Coefficient of variation (CV)	0.55480749
Kurtosis	-1.182729
Mean	5059123.9
Median Absolute Deviation (MAD)	2400000
Skewness	-0.012814425
Sum	2.15974 × 10¹⁰
Variance	7.8783498 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7000000	62	1.5%
4100000	59	1.4%
7600000	57	1.3%
4700000	56	1.3%
6900000	55	1.3%
3200000	55	1.3%
5300000	55	1.3%
3900000	54	1.3%
8000000	53	1.2%
9000000	53	1.2%
Other values (88)	3710	86.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
200000	42	1.0%
300000	51	1.2%
400000	35	0.8%
500000	46	1.1%
600000	49	1.1%
700000	45	1.1%
800000	41	1.0%
900000	39	0.9%
1000000	42	1.0%
1100000	45	1.1%

Value	Count	Frequency (%)
9900000	35	0.8%
9800000	48	1.1%
9700000	40	0.9%
9600000	39	0.9%
9500000	40	0.9%
9400000	47	1.1%
9300000	33	0.8%
9200000	49	1.1%
9100000	40	0.9%
9000000	53	1.2%

loan_amount
Real number (ℝ)

HIGH CORRELATION

Distinct	378
Distinct (%)	8.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15133450

Minimum	300000
Maximum	39500000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.5 KiB

Quantile statistics

Minimum	300000
5-th percentile	1800000
Q1	7700000
median	14500000
Q3	21500000
95-th percentile	30900000
Maximum	39500000
Range	39200000
Interquartile range (IQR)	13800000

Descriptive statistics

Standard deviation	9043363
Coefficient of variation (CV)	0.59757443
Kurtosis	-0.74367972
Mean	15133450
Median Absolute Deviation (MAD)	6900000
Skewness	0.30872388
Sum	6.46047 × 10¹⁰
Variance	8.1782414 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10600000	27	0.6%
20000000	24	0.6%
9400000	24	0.6%
16800000	23	0.5%
23900000	23	0.5%
11500000	22	0.5%
14100000	22	0.5%
12500000	22	0.5%
1800000	21	0.5%
3200000	21	0.5%
Other values (368)	4040	94.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
300000	6	0.1%
400000	7	0.2%
500000	16	0.4%
600000	13	0.3%
700000	15	0.4%
800000	15	0.4%
900000	12	0.3%
1000000	10	0.2%
1100000	18	0.4%
1200000	17	0.4%

Value	Count	Frequency (%)
39500000	1	< 0.1%
38800000	1	< 0.1%
38700000	2	< 0.1%
38500000	1	< 0.1%
38400000	1	< 0.1%
38200000	3	0.1%
38000000	1	< 0.1%
37900000	2	< 0.1%
37800000	2	< 0.1%
37700000	1	< 0.1%

loan_term
Real number (ℝ)

Distinct	10
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.900445

Minimum	2
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.5 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	6
median	10
Q3	16
95-th percentile	20
Maximum	20
Range	18
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	5.7091873
Coefficient of variation (CV)	0.52375726
Kurtosis	-1.2208527
Mean	10.900445
Median Absolute Deviation (MAD)	4
Skewness	0.036358907
Sum	46534
Variance	32.594819
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
6	490	11.5%
12	456	10.7%
4	447	10.5%
10	436	10.2%
18	422	9.9%
16	412	9.7%
20	411	9.6%
14	405	9.5%
2	404	9.5%
8	386	9.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	404	9.5%
4	447	10.5%
6	490	11.5%
8	386	9.0%
10	436	10.2%
12	456	10.7%
14	405	9.5%
16	412	9.7%
18	422	9.9%
20	411	9.6%

Value	Count	Frequency (%)
20	411	9.6%
18	422	9.9%
16	412	9.7%
14	405	9.5%
12	456	10.7%
10	436	10.2%
8	386	9.0%
6	490	11.5%
4	447	10.5%
2	404	9.5%

cibil_score
Real number (ℝ)

HIGH CORRELATION

Distinct	601
Distinct (%)	14.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	599.93605

Minimum	300
Maximum	900
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.5 KiB

Quantile statistics

Minimum	300
5-th percentile	330
Q1	453
median	600
Q3	748
95-th percentile	869
Maximum	900
Range	600
Interquartile range (IQR)	295

Descriptive statistics

Standard deviation	172.4304
Coefficient of variation (CV)	0.28741463
Kurtosis	-1.1856696
Mean	599.93605
Median Absolute Deviation (MAD)	147
Skewness	-0.0090392773
Sum	2561127
Variance	29732.243
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
348	16	0.4%
543	15	0.4%
538	15	0.4%
778	14	0.3%
509	14	0.3%
439	14	0.3%
415	14	0.3%
819	14	0.3%
865	13	0.3%
802	13	0.3%
Other values (591)	4127	96.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
300	11	0.3%
301	8	0.2%
302	13	0.3%
303	6	0.1%
304	8	0.2%
305	3	0.1%
306	9	0.2%
307	8	0.2%
308	6	0.1%
309	6	0.1%

Value	Count	Frequency (%)
900	6	0.1%
899	6	0.1%
898	5	0.1%
897	4	0.1%
896	11	0.3%
895	11	0.3%
894	5	0.1%
893	2	< 0.1%
892	8	0.2%
891	8	0.2%

residential_assets_value
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	278
Distinct (%)	6.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7472616.5

Minimum	-100000
Maximum	29100000
Zeros	45
Zeros (%)	1.1%
Negative	28
Negative (%)	0.7%
Memory size	33.5 KiB

Quantile statistics

Minimum	-100000
5-th percentile	300000
Q1	2200000
median	5600000
Q3	11300000
95-th percentile	21260000
Maximum	29100000
Range	29200000
Interquartile range (IQR)	9100000

Descriptive statistics

Standard deviation	6503636.6
Coefficient of variation (CV)	0.87032923
Kurtosis	0.18473799
Mean	7472616.5
Median Absolute Deviation (MAD)	4100000
Skewness	0.9784506
Sum	3.19006 × 10¹⁰
Variance	4.2297289 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
400000	66	1.5%
500000	63	1.5%
100000	60	1.4%
1000000	57	1.3%
600000	56	1.3%
1300000	55	1.3%
700000	52	1.2%
300000	52	1.2%
3200000	50	1.2%
200000	50	1.2%
Other values (268)	3708	86.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-100000	28	0.7%
0	45	1.1%
100000	60	1.4%
200000	50	1.2%
300000	52	1.2%
400000	66	1.5%
500000	63	1.5%
600000	56	1.3%
700000	52	1.2%
800000	45	1.1%

Value	Count	Frequency (%)
29100000	1	< 0.1%
28700000	1	< 0.1%
28500000	2	< 0.1%
28400000	1	< 0.1%
28300000	1	< 0.1%
28200000	2	< 0.1%
28000000	1	< 0.1%
27600000	2	< 0.1%
27500000	1	< 0.1%
27400000	1	< 0.1%

commercial_assets_value
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	188
Distinct (%)	4.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4973155.3

Minimum	0
Maximum	19400000
Zeros	107
Zeros (%)	2.5%
Negative	0
Negative (%)	0.0%
Memory size	33.5 KiB

Quantile statistics

Minimum	0
5-th percentile	200000
Q1	1300000
median	3700000
Q3	7600000
95-th percentile	13900000
Maximum	19400000
Range	19400000
Interquartile range (IQR)	6300000

Descriptive statistics

Standard deviation	4388966.1
Coefficient of variation (CV)	0.88253148
Kurtosis	0.1008126
Mean	4973155.3
Median Absolute Deviation (MAD)	2800000
Skewness	0.95779089
Sum	2.12304 × 10¹⁰
Variance	1.9263023 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	107	2.5%
200000	101	2.4%
100000	100	2.3%
300000	90	2.1%
500000	83	1.9%
800000	76	1.8%
700000	74	1.7%
400000	71	1.7%
600000	70	1.6%
1000000	67	1.6%
Other values (178)	3430	80.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	107	2.5%
100000	100	2.3%
200000	101	2.4%
300000	90	2.1%
400000	71	1.7%
500000	83	1.9%
600000	70	1.6%
700000	74	1.7%
800000	76	1.8%
900000	52	1.2%

Value	Count	Frequency (%)
19400000	1	< 0.1%
19000000	3	0.1%
18900000	1	< 0.1%
18800000	2	< 0.1%
18700000	1	< 0.1%
18500000	4	0.1%
18400000	3	0.1%
18300000	1	< 0.1%
18200000	1	< 0.1%
17900000	3	0.1%

luxury_assets_value
Real number (ℝ)

HIGH CORRELATION

Distinct	379
Distinct (%)	8.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15126306

Minimum	300000
Maximum	39200000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.5 KiB

Quantile statistics

Minimum	300000
5-th percentile	1900000
Q1	7500000
median	14600000
Q3	21700000
95-th percentile	31300000
Maximum	39200000
Range	38900000
Interquartile range (IQR)	14200000

Descriptive statistics

Standard deviation	9103753.7
Coefficient of variation (CV)	0.6018491
Kurtosis	-0.73805613
Mean	15126306
Median Absolute Deviation (MAD)	7100000
Skewness	0.3222075
Sum	6.45742 × 10¹⁰
Variance	8.2878331 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6200000	26	0.6%
2900000	26	0.6%
20400000	26	0.6%
12300000	24	0.6%
12000000	24	0.6%
14900000	24	0.6%
7100000	23	0.5%
17200000	23	0.5%
14100000	22	0.5%
9900000	22	0.5%
Other values (369)	4029	94.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
300000	4	0.1%
400000	10	0.2%
500000	14	0.3%
600000	14	0.3%
700000	14	0.3%
800000	16	0.4%
900000	13	0.3%
1000000	8	0.2%
1100000	19	0.4%
1200000	16	0.4%

Value	Count	Frequency (%)
39200000	1	< 0.1%
39100000	1	< 0.1%
38600000	2	< 0.1%
38200000	4	0.1%
38100000	5	0.1%
38000000	1	< 0.1%
37900000	2	< 0.1%
37800000	2	< 0.1%
37700000	1	< 0.1%
37600000	2	< 0.1%

bank_asset_value
Real number (ℝ)

HIGH CORRELATION

Distinct	146
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4976692.4

Minimum	0
Maximum	14700000
Zeros	8
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	33.5 KiB

Quantile statistics

Minimum	0
5-th percentile	500000
Q1	2300000
median	4600000
Q3	7100000
95-th percentile	11100000
Maximum	14700000
Range	14700000
Interquartile range (IQR)	4800000

Descriptive statistics

Standard deviation	3250185.3
Coefficient of variation (CV)	0.65308141
Kurtosis	-0.39727743
Mean	4976692.4
Median Absolute Deviation (MAD)	2400000
Skewness	0.56072501
Sum	2.12455 × 10¹⁰
Variance	1.0563705 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1400000	63	1.5%
4900000	63	1.5%
3600000	63	1.5%
4500000	61	1.4%
1600000	60	1.4%
5400000	59	1.4%
900000	58	1.4%
1300000	57	1.3%
1500000	54	1.3%
3400000	54	1.3%
Other values (136)	3677	86.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8	0.2%
100000	31	0.7%
200000	54	1.3%
300000	50	1.2%
400000	50	1.2%
500000	40	0.9%
600000	50	1.2%
700000	42	1.0%
800000	39	0.9%
900000	58	1.4%

Value	Count	Frequency (%)
14700000	2	< 0.1%
14600000	2	< 0.1%
14400000	1	< 0.1%
14300000	1	< 0.1%
14200000	2	< 0.1%
14100000	3	0.1%
14000000	3	0.1%
13900000	4	0.1%
13800000	2	< 0.1%
13700000	1	< 0.1%

loan_status
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	275.3 KiB

Approved	2656
Rejected	1613

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	38421
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Approved
2nd row	Rejected
3rd row	Rejected
4th row	Rejected
5th row	Rejected

Common Values

Value	Count	Frequency (%)
Approved	2656	62.2%
Rejected	1613	37.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
approved	2656	62.2%
rejected	1613	37.8%

Most occurring characters

Value	Count	Frequency (%)
e	7495	19.5%
p	5312	13.8%
	4269	11.1%
d	4269	11.1%
A	2656	6.9%
r	2656	6.9%
o	2656	6.9%
v	2656	6.9%
R	1613	4.2%
j	1613	4.2%
Other values (2)	3226	8.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	29883	77.8%
Space Separator	4269	11.1%
Uppercase Letter	4269	11.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	7495	25.1%
p	5312	17.8%
d	4269	14.3%
r	2656	8.9%
o	2656	8.9%
v	2656	8.9%
j	1613	5.4%
c	1613	5.4%
t	1613	5.4%

Uppercase Letter

Value	Count	Frequency (%)
A	2656	62.2%
R	1613	37.8%

Space Separator

Value	Count	Frequency (%)
	4269	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	34152	88.9%
Common	4269	11.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	7495	21.9%
p	5312	15.6%
d	4269	12.5%
A	2656	7.8%
r	2656	7.8%
o	2656	7.8%
v	2656	7.8%
R	1613	4.7%
j	1613	4.7%
c	1613	4.7%

Common

Value	Count	Frequency (%)
	4269	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	38421	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	7495	19.5%
p	5312	13.8%
	4269	11.1%
d	4269	11.1%
A	2656	6.9%
r	2656	6.9%
o	2656	6.9%
v	2656	6.9%
R	1613	4.2%
j	1613	4.2%
Other values (2)	3226	8.4%

Auto

Heatmap
Table

	loan_id	no_of_dependents	income_annum	loan_amount	loan_term	cibil_score	residential_assets_value	commercial_assets_value	luxury_assets_value	bank_asset_value	education	self_employed	loan_status
loan_id	1.000	0.006	0.013	0.012	0.010	0.016	0.026	0.021	0.001	0.015	0.000	0.012	0.038
no_of_dependents	0.006	1.000	0.007	-0.001	-0.020	-0.010	0.012	0.004	0.005	0.013	0.000	0.024	0.000
income_annum	0.013	0.007	1.000	0.941	0.011	-0.023	0.638	0.643	0.943	0.879	0.000	0.035	0.020
loan_amount	0.012	-0.001	0.941	1.000	0.012	-0.020	0.613	0.622	0.894	0.840	0.028	0.000	0.052
loan_term	0.010	-0.020	0.011	0.012	1.000	0.008	0.003	-0.001	0.008	0.014	0.000	0.039	0.184
cibil_score	0.016	-0.010	-0.023	-0.020	0.008	1.000	-0.031	-0.001	-0.030	-0.020	0.000	0.000	0.875
residential_assets_value	0.026	0.012	0.638	0.613	0.003	-0.031	1.000	0.448	0.613	0.569	0.000	0.000	0.016
commercial_assets_value	0.021	0.004	0.643	0.622	-0.001	-0.001	0.448	1.000	0.619	0.589	0.000	0.028	0.018
luxury_assets_value	0.001	0.005	0.943	0.894	0.008	-0.030	0.613	0.619	1.000	0.836	0.014	0.000	0.040
bank_asset_value	0.015	0.013	0.879	0.840	0.014	-0.020	0.569	0.589	0.836	1.000	0.000	0.000	0.000
education	0.000	0.000	0.000	0.028	0.000	0.000	0.000	0.000	0.014	0.000	1.000	0.017	0.000
self_employed	0.012	0.024	0.035	0.000	0.039	0.000	0.000	0.028	0.000	0.000	0.017	1.000	0.000
loan_status	0.038	0.000	0.020	0.052	0.184	0.875	0.016	0.018	0.040	0.000	0.000	0.000	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	loan_id	no_of_dependents	education	self_employed	income_annum	loan_amount	loan_term	cibil_score	residential_assets_value	commercial_assets_value	luxury_assets_value	bank_asset_value	loan_status
0	1	2	Graduate	No	9600000	29900000	12	778	2400000	17600000	22700000	8000000	Approved
1	2	0	Not Graduate	Yes	4100000	12200000	8	417	2700000	2200000	8800000	3300000	Rejected
2	3	3	Graduate	No	9100000	29700000	20	506	7100000	4500000	33300000	12800000	Rejected
3	4	3	Graduate	No	8200000	30700000	8	467	18200000	3300000	23300000	7900000	Rejected
4	5	5	Not Graduate	Yes	9800000	24200000	20	382	12400000	8200000	29400000	5000000	Rejected
5	6	0	Graduate	Yes	4800000	13500000	10	319	6800000	8300000	13700000	5100000	Rejected
6	7	5	Graduate	No	8700000	33000000	4	678	22500000	14800000	29200000	4300000	Approved
7	8	2	Graduate	Yes	5700000	15000000	20	382	13200000	5700000	11800000	6000000	Rejected
8	9	0	Graduate	Yes	800000	2200000	20	782	1300000	800000	2800000	600000	Approved
9	10	5	Not Graduate	No	1100000	4300000	10	388	3200000	1400000	3300000	1600000	Rejected

	loan_id	no_of_dependents	education	self_employed	income_annum	loan_amount	loan_term	cibil_score	residential_assets_value	commercial_assets_value	luxury_assets_value	bank_asset_value	loan_status
4259	4260	0	Not Graduate	Yes	4500000	11500000	14	509	13400000	2300000	15400000	5900000	Rejected
4260	4261	5	Graduate	No	8800000	29300000	10	560	16800000	13900000	31100000	9900000	Approved
4261	4262	3	Graduate	Yes	3000000	7500000	6	881	1400000	4500000	6100000	2300000	Approved
4262	4263	5	Graduate	No	1300000	3000000	20	540	1000000	2300000	3200000	1900000	Rejected
4263	4264	3	Graduate	No	5000000	12700000	14	865	4700000	8100000	19500000	6300000	Approved
4264	4265	5	Graduate	Yes	1000000	2300000	12	317	2800000	500000	3300000	800000	Rejected
4265	4266	0	Not Graduate	Yes	3300000	11300000	20	559	4200000	2900000	11000000	1900000	Approved
4266	4267	2	Not Graduate	No	6500000	23900000	18	457	1200000	12400000	18100000	7300000	Rejected
4267	4268	1	Not Graduate	No	4100000	12800000	8	780	8200000	700000	14100000	5800000	Approved
4268	4269	1	Graduate	No	9200000	29700000	10	607	17800000	11800000	35700000	12000000	Approved

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample